Wednesday, 15 March 2006
Microsoft have just released some test results that compare the performance of SharePoint Portal Server 2003 on SQL 2000 vs. SQL 2005.
This article was published at GitHub. It is open source and you can make edits, comments etc.
Sounds too good to be true does'nt it? Microsoft have just released some test results that compare the performance of SharePoint Portal Server 2003 on SQL 2000 vs. SQL 2005. Using SQL 2005 improves performance on every type of SharePoint farm configuration, but the most notable is a 51% increase in RPS (Requests Per Second) for a medium server farm under SQL 2005. The full table is:
| Farm Type | SQL 2000 RPS | SQL 2005 RPS | Increase |
| Small | 75 | 97 | +29% |
| Medium | 131 | 198 | +51% |
| Large | 1015 | 1114 | +10% |
| Extra Large | 1638 | 1932 | +18% |
You can get to the full test here: http://office.microsoft.com/en-us/assistance/HA100993571033.aspx
Got a comment?
All my articles are written and managed as Markdown files on GitHub.
Please add an issue or submit a pull request if something is not right on this article or you have a comment.
If you'd like to simply say "thanks", then please send me a .